How to: Calculate Variant Weight Curve

A Variant Weight Curve can be defined manually or calculated based on an item or item group's sales historical data. The calculation can consider the Turnover (sales amount) or sold Quantity from the sales history.

To calculate a Variant Weight Curve

  1. Click the icon, enter Variant Weight Curves, and select the relevant link.
  2. Select an existing Variant Weight Curve and click Manage - Edit, or create a new Variant Weight Curve by clicking the Newaction. For more information, please refer to How to: Set Up Variant Weight Curve .
  3. Go to the Calculation FastTab, and select the Calculation Type.
  4. Select a value in the Date Calculation Type field.
  5. Enter the Start Date and End Date or Date Formula for Start Date and Date Formula for End Date depending on the selected Date Calculation Type.
  6. Enter values in the filter fields to narrow the calculation.
  7. Click the Calculate action.

The table lists the fields on the Calculation FastTab: 

Field Description
Calculation Type This field specifies whether the Variant Weight Curve calculation will based on Quantity or Turnover.
  • Quantity - Quantity sold of the selected historical item(s).
  • Turnover - Sales amount of the selected historical item(s).
Date Calculation Type This field specifies whether the starting date and ending date for the Variant Weight Curve calculation will be input directly or calculated based on the defined date formula.

Date - Uses Start Date and End Date.

Date Formula - Use a date formula for Start Date and End Date. Date Formula is more dynamic compared to Date because no specific dates are required, and it will always calculate backwards from the current WORKDATE, based on the defined date formula for Start Date and End Date.
Start Date This field is only visible if Date Calculation Type Date is used. It specifies the starting date of the Variant Weight Curve calculation.
End Date This field is only visible if Date Calculation Type Date is used. It specifies the ending date of the Variant Weight Curve calculation.
Date Formula for Start Date This field is only visible if Date Calculation Type Date Formula is used. It specifies the formula to calculate the starting date of the Variant Weight Curve calculation.

The starting date will always be calculated based on the current WORKDATE.
Date Formula for End Date This field is only visible if Date Calculation Type Date Formula is used. It specifies the formula to calculate the ending date of the Variant Weight Curve calculation.

The ending date will always be calculated based on the current WORKDATE.

See also

How to: Assign Variant Weight Curve to Variant Framework

How to: Assign Variant Weight Curve to Dimension Pattern

Variant Weight Curve